package cn.ainit.bj.sanshen;

import java.util.List;

import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import cn.ainit.sys.common.dao.SysBaseDao;

@Transactional
@Repository
public class SanShenImpl extends SysBaseDao implements SanShenDao {

	@Override
	public List shenGradeByUid(String uid,String param1) throws Exception{
		String sql="select s.right_code from SYS_RIGHT_verify s where s.o_id='"+uid+"'";
		List gradeCode=this.jdbcTemplate.queryForList(sql);
		return gradeCode;
	}

	@Override
	public List getVerifyGradeById(String shId,String param1) throws Exception{
		String sql="select s.S1_VERIFY,S2_VERIFY,S3_VERIFY,s.* from BJ_XT_SHENHE s where s.SH_ID='"+shId+"'";
		List list=this.jdbcTemplate.queryForList(sql);
		return list;
	}

	@Override
	public Integer upIsVerify(String shId) throws Exception{
		String sql="update BJ_XT_SHENHE s set s.is_verify=1, where  s.SH_ID='"+shId+"'";
		Integer count=this.jdbcTemplate.update(sql);
		return count;
	}
}
